@echo off

echo ====================================
echo     SomeBank Database Setup (Windows)
echo ====================================

REM 设置控制台代码页为UTF-8
chcp 65001 > nul

REM 提示用户输入信息
set DB_USER=root

echo.
echo Please enter MySQL password when prompted...
echo.

REM 执行SQL文件（使用UTF-8编码）
mysql -u %DB_USER% -p --default-character-set=utf8mb4 < import_all.sql
if errorlevel 1 (
    echo Error: Failed
    pause
    exit /b 1
)

echo.
echo ====================================
echo     Database setup completed!
echo ====================================
echo.